package org.wyf.EveryPoint.crowd.mapper;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.wyf.EveryPoint.crowd.entity.Team;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;

import java.util.List;

/**
 * 项目小组 Mapper
 *
 * @author wyf
 * @date 2021-04-09 16:44:58
 */
public interface TeamMapper extends BaseMapper<Team> {

    @Select("select * from t_team where uid = #{userId} and pid=#{projectId}")
    List<Team> findProjectTeams(@Param("userId") Long userId,@Param("projectId") Long projectId);
    @Select("select uid from t_team where pid=#{projectId}")
    List<Long> findProjectTeamsByProjectId(@Param("projectId") Long projectId);
}
